package com.itms.mapper;

import com.itms.entity.Part;
import org.apache.ibatis.annotations.Param;

import java.math.BigDecimal;

public interface PartMapper {

    int deleteByPrimaryKey(BigDecimal id);

    int insert(Part record);

    int insertSelective(Part record);

    Part selectByPrimaryKey(BigDecimal id);

    int updateByPrimaryKeySelective(Part record);

    int updateByPrimaryKey(Part record);
//     p.DELIVERY_LOCATION_ID =#{dlvLocId} and p.PICKUP_LOCATION_ID =#{picLOCId} and p.SUPPLIER_ID=#{supplierId}

    Part selectByCode(@Param("code") String  code,
                      @Param("isValid")String isValid ,
                      @Param("dlvLocId")BigDecimal dlvLocId ,
                      @Param("picLOCId")BigDecimal picLOCId ,
                      @Param("supplierId")BigDecimal supplierId
                      );

}